Table Options
Create tables
Creates tables in the target database with this option is on.Supposes this option is unchecked and tables already exist in the target database, then all data will be appended to the destination tables.
Include indexes
Includes indexes in the table with this option is on.
Include foreign key constraints
Includes foreign keys in the table with this option is on.
Include engine/table type (Available only for MySQL)
Includes table type with this option is on.
Include character set (Available only for MySQL)
Includes character set in the table with this option is on.
Include auto increment (Available only for MySQL, SQLite and SQL Server)
Includes auto increment in the table with this option is on.
Include unique constraints (Available only for Oracle, PostgreSQL, SQLite and SQL Server)
Includes uniques in the table with this option is on.
Include rules (Available only for PostgreSQL)
Includes rules in the table with this option is on.
Include check constraints (Available only for Oracle, PostgreSQL, SQLite and SQL Server)
Includes checks in the table with this option is on.
Include storage (Available only for SQL Server)
Includes storage related properties of the table with this option is on.
Include triggers
Includes triggers in the table with this option is on.
Include exclude constraints (Available only for PostgreSQL)
Includes exclusion constraints in the table with this option is on.
Record Options
Insert records
Check this option if you require all records to be transferred to the destination database/schema.
Lock target tables (Available only for MySQL, PostgreSQL and SQL Server)
Locks the tables in the target database/schema during the data transfer process.
Use transaction
Check this option if you use transaction during the data transfer process.
Use complete insert statements
Inserts records using complete insert syntax.Example:
INSERT INTO `users` (`ID Number`, `User Name`, `User Age`) VALUES ('1', 'Peter McKindsy', '23');
INSERT INTO `users` (`ID Number`, `User Name`, `User Age`) VALUES ('2', 'Johnson Ryne', '56');
INSERT INTO `users` (`ID Number`, `User Name`, `User Age`) VALUES ('0', 'katherine', '23');
Use extended insert statements (Available only for MySQL)
Inserts records using extended insert syntax.Example:
INSERT INTO `users` VALUES ('1', 'Peter McKindsy', '23'), ('2', 'Johnson Ryne', '56'), ('0', 'Katherine', '23');
Use delayed insert statements (Available only for MySQL)
Inserts records using DELAYED insert SQL statements.Example:
INSERT DELAYED INTO `users` VALUES ('1', 'Peter McKindsy', '23');
INSERT DELAYED INTO `users` VALUES ('2', 'Johnson Ryne', '56');
INSERT DELAYED INTO `users` VALUES ('0', 'katherine', '23');
Run multiple insert statements (Available only for PostgreSQL and SQL Server)
Check this option if you want to run multiple insert statements in each execution, which will make the data transfer process faster.
Use hexadecimal format for BLOB (Available only for MySQL, PostgreSQL, SQLite and SQL Server)
Inserts BLOB data as hexadecimal format.
Other Options
Continue on error
Ignores errors that are encountered during the transfer process.
Lock source tables (Available only for MySQL, Oracle, PostgreSQL and SQL Server)
Locks the tables in the source database so that any update on the table is not allowed once the data transfer is triggered off.
Drop target objects before create
Check this option if objects already exist in the target database/schema, the existing objects will be deleted once the data transfer starts.
Drop with cascade (Availe only for PostgreSQL)
Check this option to drop objects with cascade.
Create target database/schema if not exist (Available only for MySQL, PostgreSQL and SQL Server)
Creates a new database/schema if the database/schema specified in target server does not exist.
Include schema name in statements (Available only for Oracle, PostgreSQL and SQLite)
Check this option to include the schema name in the SQL statement.
Use DDL from SHOW CREATE TABLE (Available only for MySQL)
If this option is on, DDL will be used from show create table.
Use DDL from sqlite_master (Available only for SQLite)
If this option is on, DDL will be used from the SQLITE_MASTER table.